Features of MS Excel


 
 
Concept Explanation
 

Features of MS Excel

Microsoft Excel is an electronic spreadsheet package of MS office software suite. It is a Windows based  application package. It is quite useful in entering, editing, analyzing and storing of data. Arithmetic operations with numerical data such as addition, subtraction, multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending, descending etc.) and solve simple financial, mathematical and statistical formulas.

Excel Features:

There are a number of features that are available in Excel to make your task easier. Some of the main features are:

1.You Can Insert a New Worksheets at Will:

- 1 to 3 default worksheets you might have seen, when you open the new workbook. You can insert a new worksheet in excel and delete the same at any point in time.

2. Time Saving Shortcut Keys: -

All the time you spend on excel can be reduced drastically by masterful excel shortcut keys. Apart from universal “Ctrl + C, Ctrl + X, and Ctrl + V,” we can use many other abundant shortcut keys in Excel.

3. AutoSum: -

If you have serial numbers or any numerical data, then you can quickly get the sum of these numbers with simple shortcut keys.

4. Filtering Data: -

Filtering the Excel data is one of the important features of Microsoft Excel. We can filter any data available under the filter section.

5. Paste Special Feature: -

It gives more edge to increase workplace productivity.

6. Insert Serial Numbers: -

If you want to insert serial numbers that are incremented by 1, then we can do this by simply fill the series option. Enter the value 1 in any of the cells. Now using Excel Fill Handle drag till the cell where you want to insert serial numbers.

.... (More Text Available, Login?)
Sample Questions
(More Questions for each concept available in Login)
Question : 1

In Ms-Excel, ________ allows users to bring together copies of workbooks that other users gave worked on independently.

Right Option : A
View Explanation
Explanation
Question : 2

Which feature of MS Excel allows the user to protect their workbooks by using password from unauthorized access to their information ?

Right Option : B
View Explanation
Explanation
Question : 3

Which Key is used for help in excel ?

Right Option : A
View Explanation
Explanation
 
 


Students / Parents Reviews [10]